CREATE TABLE [dbo].[AsiNrdsAssociation]
(
[ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_ID] DEFAULT (''),
[AssociationId] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_AssociationId] DEFAULT (''),
[AssociationName] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_AssociationName] DEFAULT (''),
[AssociationType] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_AssociationType] DEFAULT (''),
[CLPresidentId] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_CLPresidentId] DEFAULT (''),
[CLPresidentElectId] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_CLPresidentElectId] DEFAULT (''),
[CLSecretaryId] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_CLSecretaryId] DEFAULT (''),
[CLTreasurerId] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_CLTreasurerId] DEFAULT (''),
[ElectionMonth] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__AsiNrdsAs__Elect__0D357924] DEFAULT (''),
[Email] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_Email] DEFAULT (''),
[EOFaxAreaCode] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_EOFaxAreaCode] DEFAULT (''),
[EOFaxNumber] [varchar] (7) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_EOFaxNumber] DEFAULT (''),
[EOFullName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_EOFullName] DEFAULT (''),
[ExecutiveOfficerId] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_ExecutiveOfficerId] DEFAULT (''),
[FaxAreaCode] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_FaxAreaCode] DEFAULT (''),
[FaxNumber] [varchar] (7) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_FaxNumber] DEFAULT (''),
[FLPresidentId] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_FLPresidentId] DEFAULT (''),
[FLPresidentElectId] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_FLPresidentElectId] DEFAULT (''),
[FLSecretaryId] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_FLSecretaryId] DEFAULT (''),
[FLTreasurerId] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_FLTreasurerId] DEFAULT (''),
[LastCertificationDate] [datetime] NULL,
[MailAddressStreet1] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_MailAddressStreet1] DEFAULT (''),
[MailAddressStreet2] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_MailAddressStreet2] DEFAULT (''),
[MailAddressCity] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_MailAddressCity] DEFAULT (''),
[MailAddressState] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_MailAddressState] DEFAULT (''),
[MailAddressZip] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_MailAddressZip] DEFAULT (''),
[MailAddressZip6] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_MailAddressZip6] DEFAULT (''),
[PhoneAreaCode] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_PhoneAreaCode] DEFAULT (''),
[PhoneNumber] [varchar] (7) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_PhoneNumber] DEFAULT (''),
[PointOfEntry] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_PointOfEntry] DEFAULT (''),
[PrimaryStateCode] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_PrimaryStateCode] DEFAULT (''),
[PLPresidentId] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_PLPresidentId] DEFAULT (''),
[PLPresidentElectId] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_PLPresidentElectId] DEFAULT (''),
[PLSecretaryId] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_PLSecretaryId] DEFAULT (''),
[PLTreasurerId] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_PLTreasurerId] DEFAULT (''),
[SecondaryStateCode1] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_SecondaryStateCode1] DEFAULT (''),
[SecondaryStateCode2] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_SecondaryStateCode2] DEFAULT (''),
[SecondaryStateCode3] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_SecondaryStateCode3] DEFAULT (''),
[Status] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_Status] DEFAULT (''),
[StatusChangedDate] [datetime] NULL,
[StreetAddressStreet1] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_StreetAddressStreet1] DEFAULT (''),
[StreetAddressStreet2] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_StreetAddressStreet2] DEFAULT (''),
[StreetAddressCity] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_StreetAddressCity] DEFAULT (''),
[StreetAddressState] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_StreetAddressState] DEFAULT (''),
[StreetAddressZip] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_StreetAddressZip] DEFAULT (''),
[StreetAddressZip6] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_StreetAddressZip6] DEFAULT (''),
[Webpage] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_Webpage] DEFAULT (''),
[NARTimestamp] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsAssociation_NARTimestamp] DEFAULT (''),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[AsiNrdsAssociation] ADD CONSTRAINT [PK_AsiNrdsAssociation] PRIMARY KEY CLUSTERED ([ID]) ON [PRIMARY]
GO